SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805451 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805451 [ RunTime:0.003711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654511,392020,777635,944589,620482,999546,857851,794782,585412,643343,44015,682826,57905,556278,713014,788892,231427,559386,82500,718203,338567,788473,211354,629185,90278,417296,571448,326569,896192,880251,265070,369894,438053,866462,421463,240539,659477,949868,506580,394355,677780,405143,273108,469921,198638,537495,924952,265193,87944,915975,266989,204090,701732,529418,992916,867557,361072,709865,1048787,231015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000887s ]