SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396433 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396433 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529226,717901,473738,458081,113622,626598,836883,51986,474713,276807,1008442,653859,642350,924098,795460,620838,46481,5464,424440,375301,912190,525699,676584,859847,200605,935207,24640,1047686,839890,151112,769799,625881,67909,282132,115257,47505,886088,770425,969454,674223,548294,58891,920757,495105,923479,721372,898608,96470,46590,223087,311862,836613,309551,660088,896368,655558,357879,933965,819876,156300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]