SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809422 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809422 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812099,272937,761852,379042,565578,1023502,524154,562350,244555,199278,384608,244266,679712,931827,305575,170076,1022040,665608,12362,441141,316541,115779,607387,257827,590306,815055,393987,621739,964199,200863,883914,414297,822469,712576,91897,845595,993864,492260,878950,77927,923719,237549,228798,220573,356819,615858,824684,340379,1041481,57849,591692,883546,707412,500738,452347,188587,343133,392280,174825,456507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]