SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507941 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507941 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39972,927120,439264,591027,349363,271937,162656,92670,590740,969201,128323,909073,796511,55276,201759,6187,40008,485032,298884,190216,464884,861141,37952,609639,421418,669821,1004361,981479,277527,250992,836508,1038423,403689,361453,788997,770187,835140,591742,518607,672166,1046106,1040485,599298,851978,845337,698077,493091,415046,579540,271430,965327,578681,908031,305407,804153,436977,436336,210883,246396,894650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]