SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430510 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430510 [ RunTime:0.003325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58049,574079,967196,879702,970135,1027306,538172,136142,397121,157772,944930,365095,1011105,429428,1030048,969703,930482,995512,1013885,453144,772230,585718,923638,124816,994752,429581,445386,1038830,385482,437549,615846,486379,617680,777906,740000,552215,858980,840558,509383,804645,602090,910113,700318,657709,831256,175813,387927,772004,602816,363926,1008473,250292,751916,646677,706076,951135,15066,30829,284794,336756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]