SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331693 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331693 [ RunTime:0.002952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619793,120998,588092,672096,1013044,201656,551531,315486,700322,168368,235327,485957,622239,335894,864370,142392,779842,61850,212246,716543,966304,693651,356114,184241,958944,753781,952906,135501,229800,945060,178554,537052,187237,452316,510273,541134,922076,766533,656961,1030312,908375,201383,201347,363848,940774,345840,1041449,292680,754316,179302,32290,1026991,579699,325764,932870,547981,738713,523283,599817,505404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]