SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001853s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569075 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569075 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502742,865511,928186,1042330,822787,912132,726747,649503,465342,592690,517374,206487,87286,419080,423136,300922,730702,612927,362776,224046,969131,688386,622987,106787,924413,775674,859681,858209,903044,793355,639036,346721,666518,55075,56452,656343,405534,407239,154464,796287,764025,65280,18951,879731,513029,950244,997554,611369,969903,485830,991281,687276,592491,101101,106160,572954,889272,784864,945880,1025753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]