SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016071 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016071 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594891,413504,974293,675121,880605,100467,449953,588804,842007,289876,586639,736612,576409,944056,649999,370976,222958,157310,147138,1002937,124433,291433,733229,847363,118325,1040783,368566,687874,424450,402882,39614,256261,620296,578246,376103,372419,645464,640575,585515,265445,58166,183150,990897,569449,244999,674819,274881,18294,465426,129569,64980,491127,136867,235863,913147,338956,202390,418029,359197,5224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]