SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028783 LIMIT 1 [ RunTime:0.001293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028783 [ RunTime:0.004544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456352,343884,854282,670149,133868,167935,344395,983868,780300,481612,1029762,796047,298586,476854,28136,589233,929549,171348,3497,24505,985199,225986,678176,104676,906313,807528,379599,1026470,846545,412149,396819,103163,102917,243192,1029854,421790,850297,420419,687824,548922,230958,180344,774890,639738,369922,701299,869256,440467,1019746,459529,205651,972048,241619,422612,450982,171496,772449,347225,513195,165799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028783 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028783 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]