SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002454s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405553 LIMIT 1 [ RunTime:0.003679s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405553 [ RunTime:0.003783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629039,741999,259369,307115,321704,676152,148189,1034932,223891,860124,744793,109605,953798,387929,702368,723996,856143,299657,271696,297817,661226,124159,988290,117704,828693,974982,790577,647430,302380,944622,579396,485091,408318,523825,201753,566071,1034783,405865,174812,715044,1012568,1031705,287326,970270,683960,340527,50057,851460,959666,670166,338327,675756,767090,1027986,495757,770548,929068,337638,128121,580978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000783s ]