SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501758 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501758 [ RunTime:0.001446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675760,937323,215260,405616,278796,289772,474467,941055,391695,440319,574501,922627,466316,113585,620198,321483,611285,496720,983250,111223,968864,809210,436593,626314,266595,144419,98036,951808,22377,266033,390575,300185,466471,741458,123338,507661,855075,876848,46640,932351,754449,321930,1032986,758114,758419,1025443,443987,320921,526168,624076,501570,517464,376350,383010,690693,905644,575067,311425,86997,868902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000391s ]