SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205436 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205436 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606380,1036501,476496,960779,986350,559789,39358,670966,229568,41734,730676,837195,61461,708710,809325,375275,1002618,588609,574236,118227,376315,782155,316919,262891,267534,795766,938578,337155,1026287,1009903,831457,419904,545189,357016,573995,254416,32297,522316,1047410,668624,219104,125206,277106,293205,230134,670318,547146,964941,712393,589109,127923,885172,901193,146620,96420,703078,932183,738889,80452,496027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]