SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910417 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910417 [ RunTime:0.003035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352016,905086,1040059,290501,622241,953610,138670,139914,396224,841723,1036023,876206,375874,405085,288031,156892,577499,1032736,53980,327301,794228,465643,138619,548891,168386,227352,441579,684529,441046,712314,896874,884414,909811,137674,595913,314430,962606,951331,826633,246321,661919,160837,1046575,531279,551745,633576,549330,215105,1047872,325264,825409,402400,1019077,731876,451674,674519,58340,1015242,886507,866020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]