SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394317 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394317 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364222,123756,697847,360175,552086,960272,104147,781508,670847,282788,287777,716687,130417,124397,225106,597791,1004960,576476,607070,788518,293061,639095,891679,322535,1034013,472743,563329,656245,251941,371521,32000,911976,119071,150256,172042,603245,10484,768804,69259,823764,167716,794419,843947,24606,572754,989178,886705,481551,664857,963676,66736,81876,1001987,240881,544851,117566,232342,581412,595684,626405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]