SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587978 LIMIT 1 [ RunTime:0.000820s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587978 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479439,561937,711703,918721,871221,392439,123316,286419,398394,768679,695132,933085,340558,768673,448080,774580,168979,134450,421881,280823,311264,638246,381832,284390,941302,786051,900989,761073,739957,156999,383922,438226,109469,941068,152610,378648,285937,901408,1011699,797710,523124,89584,820011,706734,737693,376689,113994,752700,571161,934234,64726,141325,545361,912003,234487,540154,662022,657945,317545,102508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]