SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031643 LIMIT 1 [ RunTime:0.001594s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031643 [ RunTime:0.001906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932540,449097,859510,362309,933240,639093,660600,318431,589892,631523,120809,476639,1011767,260205,646801,137802,665152,885550,834276,747964,535420,70458,174280,76901,416324,423365,40280,1024796,645743,581841,619617,2720,444913,1005680,1034877,756034,764567,809825,901806,602267,387477,612739,77201,21336,427772,168369,440581,633649,760647,232514,765912,923457,847936,908943,510256,971870,352310,620164,30163,322716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003108s ]