SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263380 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263380 [ RunTime:0.003724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693483,18705,632675,169496,503409,90887,582483,994970,725620,634422,587071,456962,307689,969798,152531,880073,25002,690641,542927,790838,465740,748582,287889,919971,402035,48459,410585,611030,282812,707817,493371,602831,348862,75688,787435,362507,647131,381808,495307,508423,1020309,402597,924058,935915,1024844,964862,64676,684334,141112,504168,749396,193029,299644,619838,67637,831602,993286,307480,163896,94849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]