SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44222 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44222 [ RunTime:0.002242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988966,645169,572715,236645,325877,757348,214062,862784,503071,1037342,28284,324094,610546,123897,95631,357431,556648,29741,11153,346135,426904,147615,825562,113538,543955,114687,85387,166453,904410,804164,151702,168579,944044,285379,182467,36126,403480,225864,395253,679318,370952,519118,705871,517964,314840,191562,775096,113882,817806,884578,806531,800986,22504,500866,131850,226399,131748,293943,771855,181721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001837s ]