SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014740 LIMIT 1 [ RunTime:0.000829s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014740 [ RunTime:0.006141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939812,257479,893982,305885,345195,892787,1036253,1037101,312362,926419,558558,587225,397620,47461,391779,888718,856544,11813,41337,443272,486403,390206,928147,96461,408744,758509,5378,465877,706317,160184,122904,365539,609769,10465,259579,748164,255461,188586,797020,157080,118474,213316,669530,68873,868808,681245,1023085,227454,846352,341870,363049,186426,729095,781574,1039732,336,554054,257352,694351,936580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]