SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485929 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485929 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143261,295775,1007799,182000,603643,181873,791358,199874,350661,150837,276291,1388,731570,3104,603196,479930,544363,137978,883568,676666,503687,524277,44340,89091,1039774,346351,716317,331640,994081,543199,308306,739046,219323,14265,440158,65,176217,23872,164618,189303,531662,416989,758494,1041536,449538,780421,625723,885513,918880,823639,429283,94807,748420,712913,787492,366253,898171,811237,753269,883693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]