SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036659 LIMIT 1 [ RunTime:0.002502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036659 [ RunTime:0.002980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319797,193532,373793,180498,889872,792469,142138,745130,199094,19956,410197,429406,712337,665344,685937,920160,258653,718605,488570,661320,370645,218511,551204,676592,143577,717545,399744,58079,981802,271601,693058,772393,218296,890008,697198,1009996,52767,210619,906304,837696,14973,68710,1003284,609833,527014,160410,597392,682025,410519,710210,439704,583060,796978,261841,269282,551101,677542,916550,750957,17106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036659 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036659 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]