SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 15800 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 15800 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339072,1037820,630057,359677,599897,1026262,135034,837448,73329,899232,375907,504587,146067,863010,215972,95248,784710,335629,304717,374130,50187,254537,37610,422781,500934,828974,528738,300384,500969,126178,190992,902551,483148,1002102,702261,590486,980613,411183,877180,517415,360304,28501,731490,797709,701410,687559,365439,991435,350459,421987,333186,96164,291022,478225,921043,312421,167815,450578,517666,161404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 15800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 15800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]