SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101504 LIMIT 1 [ RunTime:0.000714s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101504 [ RunTime:0.002219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271872,728377,962697,472493,408657,231531,763502,3151,383746,437963,139262,892614,331817,1021876,1029686,198032,938525,1024712,681103,710888,817351,664251,1043319,740479,1022091,65103,371628,696485,862198,1029868,107744,232728,895657,668590,693486,719708,969236,430574,34693,384077,405996,454773,406500,443880,1006004,1043371,39740,235525,322507,903660,586690,131623,410042,220099,229531,706876,375579,1042368,848279,852076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]