SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 15320 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 15320 [ RunTime:0.002843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103803,788553,278750,218149,622646,598158,465017,742815,135061,291228,28347,238091,146476,634667,310750,3610,70440,129901,491840,134895,226297,542138,761504,311977,407059,743121,568077,669564,234826,765900,218121,225785,27486,1028818,1011379,658097,320383,385392,167155,592396,275159,952640,59460,827690,928182,274361,779271,113651,234044,348977,496169,926892,263266,114588,677928,953447,180391,649688,566332,491249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 15320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 15320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]