SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346991 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346991 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332925,635314,374899,665951,835728,447808,43917,1021743,368900,631518,584623,89741,121644,799750,750700,577286,826302,193817,102366,786113,445236,56864,976960,534178,963977,83369,307248,5294,31315,907638,547226,125661,406879,449435,566692,732854,490175,986857,348905,198946,566167,57231,623287,939822,159633,552018,97435,1044363,981381,988843,442389,655208,384259,200517,1035813,834428,959184,80746,947664,798336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000375s ]