SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204680 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204680 [ RunTime:0.002652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888741,50495,545576,685314,138266,151110,40693,666859,470508,171533,453349,961977,155990,688763,992735,348952,302269,902350,702256,1000707,1006517,142794,805612,659906,855410,746804,803186,894543,1021841,899136,975375,813958,381833,344214,328578,461103,757213,723279,202012,1021025,308626,648643,878184,914628,607760,862980,731418,868620,1026988,370304,439580,782265,74022,516,174383,78239,490968,502959,20586,872943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]