SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506101 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506101 [ RunTime:0.002491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147877,38906,444294,515541,260441,58978,639097,621453,96021,255446,918732,198771,300382,188257,163573,227572,230170,579128,185882,922494,912201,433233,350766,820017,398674,622582,330538,681536,1019893,253316,293307,294145,731443,950308,218944,898025,175520,940779,214006,435020,820691,854775,436785,134504,362799,406657,437640,198213,148649,325045,1005654,69859,804921,441203,587399,453738,623486,807230,303646,221892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]