SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001920s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195829 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195829 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197703,770937,405131,177096,482040,1042717,473595,281640,313783,575378,742904,804254,290815,638915,122370,857313,949258,628380,810083,261796,149134,128792,418500,585072,618451,374894,753794,192863,446421,469073,991028,1045828,475541,228641,778715,259056,366781,209585,155799,890123,72423,935858,681960,750242,722296,306037,1040092,714211,824089,564000,1025783,256042,841332,799032,114236,507560,679561,174674,784719,178975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000767s ]