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` = 485221 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485221 [ RunTime:0.005337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492015,511589,53518,401728,341269,142258,100439,273707,762967,406904,673116,456994,33738,972993,567960,264420,226451,95802,478308,285066,473787,847843,51792,113272,225551,85279,33385,789201,844868,940134,637225,886454,891307,596237,493373,505105,745541,506505,196599,247316,432313,444199,748509,1016746,549916,978050,341899,894474,733437,964958,626803,62498,738104,1045544,733806,27263,263793,543767,598005,357549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]