SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507276 LIMIT 1 [ RunTime:0.003772s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507276 [ RunTime:0.004625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343257,903270,170582,1027991,662950,632835,222989,51928,797879,85064,899122,502852,650062,797251,867017,310451,249202,944681,130022,921205,416042,538467,955480,190918,231459,306456,424598,877794,188305,284055,105599,676543,43143,568400,808755,244536,282871,277330,601763,993854,1031105,186163,27071,512317,906672,825663,1026190,704655,309584,858800,658054,930202,764845,283139,762066,389928,486291,1018270,503965,449807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]