SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316409 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316409 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11379,721130,192180,281501,1023248,403048,547972,189701,974656,959117,315234,517575,855320,554918,557910,17518,72687,190781,612849,536714,544783,779895,501996,155033,69703,854350,1039905,1045465,191956,789768,895483,900082,874640,674193,465026,557902,806369,532932,478440,941136,706189,482767,661819,85446,640122,1014717,832281,37964,898608,83496,857219,414286,1004085,562517,429157,788274,878160,163974,956142,132079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]