SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592311 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592311 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484156,578439,435367,116024,69081,536370,210739,604453,905327,849622,423241,99532,539562,808960,4396,785340,763538,408873,763457,973034,234656,214100,693644,126886,1023300,26129,650447,296052,1042539,953093,545216,634134,100765,291763,578301,1038360,278551,940001,860794,140163,1034333,969876,388812,740124,362232,98129,347199,541073,347498,716753,793771,754947,967225,78313,135331,297489,943500,70986,1034308,451582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]