SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482511 LIMIT 1 [ RunTime:0.002213s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482511 [ RunTime:0.002252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281254,1001154,557258,607159,812321,242288,374440,432780,172884,462757,135345,240669,853605,591481,680292,952226,307184,763049,523133,205526,639774,1042435,1008100,430226,532294,122658,276445,568102,155297,996683,177706,216279,33187,564645,392230,844728,888738,851794,832772,284369,188648,392684,905455,227654,803643,624782,694922,391153,372969,161133,317381,253190,296963,110307,969759,315255,390089,52188,757261,14072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]