SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814043 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814043 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451179,188930,226607,5990,473048,67845,802955,210719,766145,479707,446566,169325,750540,78744,343830,66681,1046200,522472,715057,524165,446387,671797,1010418,141145,617106,372306,387240,324871,167245,976730,648509,551057,855412,679297,476549,287981,506087,495586,551742,282205,326727,982731,305866,956353,18350,808172,166825,609151,260004,326312,154720,175818,885268,62683,502669,54357,301292,29587,41777,317258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]