SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803213 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803213 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44722,882377,883425,202178,41762,184215,922500,161144,206158,771849,862983,749714,844891,19028,499822,204260,795826,973220,443537,470646,897199,693606,239762,216200,800024,326992,800796,875338,485036,280474,600149,110732,84292,372769,526738,947704,953388,495390,1010478,968273,932330,713365,719654,245404,734984,861187,970887,583415,101279,728735,661894,677027,594330,651615,888102,985416,872618,275817,144435,112140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]