SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242843 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242843 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385272,787782,793095,194493,396707,1025802,328201,606562,493150,723009,408718,348298,1047790,212530,551162,975635,1011269,1008469,298812,89843,12951,327735,254619,488785,145451,690509,308066,827279,843192,254115,177027,63093,248095,374522,726736,648957,844250,422583,789606,898075,81692,305367,896309,997414,945005,706776,504887,633233,661232,145221,1028370,672533,116823,443540,913989,1007753,350092,517736,360384,438756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]