SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031029 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031029 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17962,577597,141123,606758,709824,212392,985193,431990,480399,834033,560597,125866,822722,1044226,479771,296996,728826,719999,523403,805961,350440,600898,768338,603996,526298,373633,984100,133841,88198,705989,53043,864703,137850,333631,79247,702460,162674,606039,915016,236614,422441,51359,587971,728754,338004,1009679,782635,133192,713112,622631,793231,540210,406195,101103,138060,61559,672909,361742,367420,803746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]