SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002881 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002881 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280236,522283,536369,789930,465446,415591,981634,263949,233226,126864,153272,501207,363493,664746,441833,591092,945963,165170,924407,438820,556507,1007898,181777,593327,95004,429541,88687,464430,601958,367159,469223,994679,696537,834828,956561,593818,423160,106298,297663,121341,257142,618163,725381,859007,1030145,299630,493246,793514,192825,804037,60481,652571,631071,183837,225567,86375,1034103,570143,896814,704174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]