SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358474 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358474 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353912,622400,397900,241361,1024554,351049,18206,33980,606986,384108,282947,470972,833065,155331,311672,98457,689776,745879,243898,337819,848727,402990,167733,1042558,1000368,851569,951955,975880,111084,88607,112711,105759,679318,695791,455496,956626,56650,578302,451180,690101,498723,1015946,621285,142208,23391,784909,24266,586470,399475,476459,840110,918933,650975,665160,514475,638534,243158,52467,650177,519826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]