SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205606 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205606 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294450,36279,313382,762009,892071,533769,931964,48650,986093,626984,659102,649144,143230,651533,294922,753087,619785,1039696,711375,610533,417791,977900,669051,364323,476414,925388,716740,121690,748001,957647,545992,148171,372648,216739,490767,782264,1040743,728191,357066,155181,870869,955599,640708,238589,753453,66292,604067,510424,850427,259336,982116,291629,764225,33851,591082,228670,603940,900723,797549,792838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]