SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141054 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141054 [ RunTime:0.002617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453566,326721,699900,1023764,853622,424578,123652,668231,1047297,1039737,963482,896195,724220,320041,988792,186812,395369,636416,589630,39739,214667,209498,347433,558430,975886,776132,15027,100443,99523,158972,807768,267326,128599,569909,884091,95127,364834,578975,200186,142400,860516,910051,485582,765894,563563,108550,181726,189076,398034,143199,884965,645826,288712,335161,157922,477959,23277,80667,126789,124925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000841s ]