SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038378 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038378 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457187,295663,14147,955141,731760,427505,940240,1026484,429722,671909,446394,771651,450020,499423,419579,745361,956865,934471,718632,726437,951554,771445,94816,752075,657525,901584,379390,477712,125189,131674,667356,464548,1039704,301342,692542,313063,556788,87154,1007718,72506,124700,723799,251760,972011,628477,595333,107489,293358,983910,239828,990348,501257,287521,951439,853194,286305,279314,356759,496178,704539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002836s ]