SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336746 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336746 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332013,801206,705765,494748,970522,699151,1027022,602628,311034,122012,861507,639633,706488,783433,509698,826199,256876,496574,444272,514527,197798,906839,177399,769510,211732,694764,699619,376064,211968,315386,657495,1009202,209081,350846,385939,828652,437057,622412,843465,598985,705093,1026691,338202,501286,920271,1031040,231120,1016445,682426,54708,295235,661749,215296,506557,971632,716404,858311,231723,509754,40228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]