SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200325 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200325 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847702,1016123,272678,66664,158273,226275,309663,537952,397842,1026268,882373,365351,871541,961513,927688,506276,790912,738663,797352,988747,898613,936639,521451,632970,243399,627349,160988,945811,343673,741587,396628,33244,1010705,816967,831145,836498,201043,343329,633113,140053,773516,203183,663844,958167,949911,689446,419091,664156,734250,57691,770840,662640,261766,257129,39442,968647,68415,572334,271319,151185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200325 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200325 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000793s ]