SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335452 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335452 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446028,612849,463934,13147,825903,675213,835803,168267,498852,1048303,1016679,167020,888707,604433,623162,599095,582969,810100,242315,69143,998853,241751,771615,845325,710930,376033,337019,99042,500722,878344,790484,686871,139131,679510,783121,345045,970151,337730,651599,242645,894519,379975,691035,639117,1042824,151513,583747,331070,188254,953021,392470,427190,888634,82825,671018,629955,557081,409053,873303,485895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001200s ]