SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493400 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493400 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640076,183604,962386,648423,1024014,125754,678061,54601,448577,465913,847940,450259,828346,994652,1016510,962283,1007608,236122,87008,982361,542061,195106,288729,997786,472643,755022,154455,792571,35267,503199,348713,1009213,817693,353338,26400,429210,399927,586378,547799,970181,366870,273878,980831,199122,901995,529213,373398,346944,597051,933276,120190,55685,907679,483146,44655,644862,567785,631916,883093,214496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]