SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001962s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 206385 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 206385 [ RunTime:0.003987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707389,1003680,1028360,940789,481796,1014361,206810,652891,749500,1025016,830269,488737,354003,250312,1015008,320030,689359,844174,738133,945227,348330,966790,1031519,462925,432609,604767,781599,434255,446805,572042,171226,740602,188742,205868,544310,446294,828836,996384,549929,24096,97921,497141,22647,985512,742699,453866,999992,212753,724807,930425,85507,202528,857813,114783,197149,260769,675723,481419,204549,972366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 206385 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 206385 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]