SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563428 LIMIT 1 [ RunTime:0.000468s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563428 [ RunTime:0.006594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720205,52784,125267,985709,666023,1021168,1008545,138956,581913,342982,416500,733717,584059,253647,689747,321179,149779,100552,477089,1010146,305482,941130,336465,939768,965795,148859,127330,1009303,945567,412219,385242,202204,946204,878380,656085,350749,248037,508918,193536,931255,937224,119133,1029769,95022,808072,227622,992275,709833,1003431,298239,185895,499900,576496,355565,301753,77565,489443,797618,227011,848906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002728s ]