SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325580 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325580 [ RunTime:0.002967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231990,128335,452564,1016033,717105,755432,873806,618535,715282,150086,439362,18175,886510,790607,325056,287306,990040,940676,813855,559433,889277,938188,399128,877743,406120,850908,66164,578625,346206,338376,66645,479898,501632,397068,277056,120282,718663,225324,319195,962016,153569,967487,472363,295208,708573,72179,843481,240202,719767,532677,864172,894417,196836,502575,993388,24926,864882,955240,885418,999159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]