SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536906 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536906 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885391,334090,880861,578546,565402,68166,840978,932033,719756,534243,430089,756679,763352,572990,747707,652622,609850,471603,602491,433086,965433,391355,755432,489244,826708,632646,686757,265192,217386,169421,611648,788911,1004114,349081,744670,822770,812124,274576,969710,835534,488036,689275,835712,714217,129051,377028,888772,11164,528214,157263,931477,1013641,940293,1005722,956350,159605,96964,264070,415629,858224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]