SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520399 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520399 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523525,839401,388128,272706,457940,817613,1008836,414575,290333,712074,89097,734290,743489,348150,96494,659146,371360,702078,157930,376974,826082,45108,625857,296871,905593,686073,472706,30717,659765,620911,644060,155274,759245,302345,36224,445972,605774,1005589,166242,568325,726897,554454,502272,460244,744917,113366,22515,848624,737225,527289,6398,351742,253379,841573,26982,35090,997369,223169,309634,10263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]