SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424311 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424311 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685039,840078,172870,1009468,307245,411736,499661,3785,731631,217986,547641,862790,102042,302936,787616,578661,260714,286333,1018887,202458,515934,258672,478141,674666,242315,690385,13687,302933,608078,339133,366856,59341,35106,188442,215743,366645,894112,1003331,961300,841060,768834,987188,572584,941326,143201,709949,42948,578002,300531,197999,722347,458032,734135,1044314,171790,304275,54963,1037443,421980,1014311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]