SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420613 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420613 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048136,883427,169349,450108,1002133,130828,151931,664277,976164,152558,517775,207990,45817,268928,1026968,260029,845103,848811,951828,492896,586058,357690,217838,353282,465003,283510,955664,854588,884145,855713,1016254,393171,647856,709634,1016109,558943,349773,131694,602497,186731,305679,647232,38042,998774,167103,349021,225355,313846,39333,843069,871394,22141,930207,927739,263955,52329,602154,647493,725394,130631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]