SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020476 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020476 [ RunTime:0.002758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52475,522082,431226,194012,816306,51086,651037,164390,271920,1041299,443885,579510,21889,994971,465825,520390,1020053,528911,710143,520735,482940,1017603,706362,749391,836762,909856,480234,28421,784091,577920,1019983,571407,66889,108184,618935,420152,966856,903287,454613,582191,488127,961509,994303,658728,725701,380357,488274,802977,988711,882344,43761,532133,350074,495050,121984,207885,643324,581188,960545,759606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]