SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474851 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474851 [ RunTime:0.002978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822544,354906,970739,343463,396776,869081,102866,675657,102375,1002857,519874,772458,225961,256939,26808,256522,341930,1023939,38762,323243,735114,37945,699647,807209,332410,50364,903743,419220,802581,151860,858748,364420,429655,1035569,108186,61561,345365,422964,920237,418028,482523,853560,1046795,979629,124013,194941,408824,534104,448434,652870,554132,136024,1017409,142748,527754,985662,583900,438888,249722,566833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]