SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455183 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455183 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285635,843519,55546,383712,25763,7086,600751,12818,282799,996865,444428,295871,870654,575087,967450,408683,1002867,381719,112725,459293,403615,1047297,565377,739806,1007915,999059,281548,834022,595712,986121,473747,219453,1014139,141217,409604,861520,669488,997573,306842,960305,1028115,994542,867741,14671,222304,376970,67742,636649,1015629,28243,794352,346359,940653,516137,977920,364515,711207,475501,233307,199103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]