SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 273407 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 273407 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489883,548395,654382,994569,528941,700710,699971,942695,591406,297124,166547,598163,153548,232472,426087,252082,1044172,188208,1046428,29967,704024,110707,552707,107914,971017,49587,1047296,755065,594413,581450,609214,815896,771266,126234,384288,616663,254998,18259,517254,875523,354350,451012,395994,423787,835285,354132,111964,840591,197174,1048471,252393,161482,1003091,427710,481326,231570,944255,621373,600124,437869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 273407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 273407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]