SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480570 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480570 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755668,470340,178734,26262,207507,266963,9827,811321,85699,157987,529489,237353,274438,1061,541837,867428,732718,380602,208087,391763,151718,397178,602311,938812,695561,48690,909010,274472,405413,104747,877139,619571,639669,438136,749777,353174,454433,213549,950766,325612,615570,760682,827180,1028677,544303,305404,167310,688302,682962,374059,117102,662830,384390,285696,440075,801154,160803,895219,228540,254467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002287s ]