SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 360475 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 360475 [ RunTime:0.002997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504189,914624,457793,447241,542927,43835,695467,677931,114423,873715,863928,563610,741072,337134,1007814,648342,851412,570430,310931,419976,941061,690634,460931,258237,634226,136583,1015417,719427,117070,1011433,721193,671591,323933,831696,595522,435921,512825,243314,1004868,197472,577688,18754,126673,213416,67346,734351,863437,430917,939169,956004,327293,542426,730305,787113,910865,41908,799600,839014,743410,1041328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 360475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 360475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004668s ]