SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001867s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589897 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589897 [ RunTime:0.002762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123991,311320,339879,772564,668607,1033895,685007,330447,976613,306889,543888,75448,1007308,102732,439241,498701,929388,178879,1014880,803817,657135,665465,781520,790579,242488,916743,348501,720152,636672,902507,539647,505909,430863,459177,855702,696641,678123,514201,433174,650945,297177,878558,127732,353575,991067,464084,643844,240685,958309,550857,262583,414600,317001,322690,382542,257846,743117,1024289,585211,299803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001706s ]