SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195069 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195069 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598611,857845,110257,83779,756834,901153,160681,275479,744115,618380,412367,277692,102536,12859,157185,955188,934675,593127,916597,546374,177751,893594,397269,772158,673913,483162,406044,6182,200763,621613,318908,315123,749316,736240,543422,793890,1026398,482256,559997,187821,118885,978097,358413,260010,842304,495136,400921,596098,485858,17700,935654,259516,378552,200863,796180,200041,481252,920040,830417,952850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]