SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430760 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430760 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54664,450775,760566,941107,600838,350860,1047446,107017,507632,123964,770525,254099,808985,168654,994489,1011009,955549,1045696,753839,511264,804723,990657,258485,260884,523330,101395,1036243,592259,691434,296768,399759,824296,112955,762561,783640,665126,821880,445216,598439,772491,942330,204109,239213,593102,888614,690792,162983,77627,324271,655716,510027,895676,565252,390319,393486,454551,390187,420585,15924,206699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]