SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024068 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024068 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452876,556308,256888,132891,252617,405762,477485,928432,358846,599036,607880,281589,262794,175772,100044,578478,869518,616412,520304,896882,767728,154852,1033926,282885,90580,605929,1038764,330145,256369,529999,821685,268691,920309,893767,405361,970562,4364,956200,275731,793619,302214,620312,880432,210043,636786,841221,155289,804789,428970,307167,1019270,35943,127272,929961,835604,809936,204568,269811,425350,580107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]