SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045718 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045718 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674277,802903,101544,415588,663504,222742,714825,793459,707889,203419,61427,869685,183746,320305,401157,491835,204272,80928,921260,248470,407639,976497,100143,576964,485869,641058,487850,193235,218607,159867,828412,832718,837044,133464,923286,53607,749382,918082,838483,592674,796120,1009787,53282,559370,262466,518641,865002,353265,580821,511162,348610,784560,377867,364298,378219,913911,242341,895371,165762,5040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]