SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195494 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195494 [ RunTime:0.002759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53893,50299,774657,733772,6214,256099,196990,661562,701713,254720,6565,553502,644456,843325,644045,875615,73428,484187,97247,739035,790726,415726,63365,376499,65225,611759,316345,194002,297079,921957,964176,43324,1012342,867136,463740,299882,1031196,856039,23903,785163,560169,328646,887406,943623,538202,114452,185132,582878,646646,362599,683975,323706,270366,126172,838918,501765,626170,727103,175724,504718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]