SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502620 LIMIT 1 [ RunTime:0.001108s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502620 [ RunTime:0.002752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990654,601846,265139,566189,260906,207747,881188,475426,877056,975861,956587,56215,357880,547313,488461,945856,947347,840713,225325,374012,11491,963799,751987,483613,291125,707573,609448,481118,671033,341932,442503,222222,360817,912464,1045763,4081,366782,172291,247369,665256,85451,95315,787736,790201,383398,74078,549475,959875,885434,468713,239457,937280,668396,6137,743371,642824,418076,63187,99645,210465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]