SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426061 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426061 [ RunTime:0.003835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133305,767162,209774,445369,932093,276106,914899,200380,108116,67577,932457,412420,940176,927585,3893,705106,782816,6042,381005,484564,999331,413468,668240,392015,375398,535824,250684,397105,200160,1018808,435608,557540,1024863,222955,852363,704907,305635,773422,524451,170741,842779,109483,921017,397035,650314,142101,87411,27581,811987,147969,698009,306154,845233,854077,712751,568701,159859,41775,213739,910860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]