SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003774s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547563 LIMIT 1 [ RunTime:0.003063s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547563 [ RunTime:0.003260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673076,11033,834827,145317,265933,397035,267467,539165,700966,897025,539690,659162,428722,759419,1014586,50265,188010,102432,894536,115273,126696,708098,702771,985668,845440,849278,300765,488049,329395,666829,320864,390628,591606,535997,937036,856266,434778,352381,543703,813297,506284,146685,319003,362586,261209,414373,695845,595710,177974,715688,399870,128563,272683,133854,540314,288315,509872,608330,758392,413691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]